EVE Search - phpBB3 API Registration Mod v3+

Check My IP Information

All Channels

EVE Technology Lab

phpBB3 API Registration Mod v3+

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]


Author	Thread Statistics \| Show CCP posts - 0 post(s)
Keil Sonter	Posted - 2010.04.19 00:06:00 - [1] Hi, Firstly let me thank you for taking the time to work on this as I know the effort involved and the work you will put in... Now for the bad bit :) I'm getting and error on the installtion at the 'create database tables' stage. --------------------------------------------------------------------------- A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance. install_install.php [ 1230 ] SQL : INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0) Field 'api_userid' doesn't have a default value ----------------------------------------------------------------------------- Now I have an existing phBB3 installaton but I have setup a new directory on the server and a new database so I know its not a configuration issue or compatibility as I already have a running phpBB3. Looking at the above the last statement 'Field 'api_userid' doesn't have a default value' seems to be the sticking point. Also the SQL INSERT doesn't include the api_userid in the field list. When I look at the database the tables are configured but no data has been installed in the user table. This table should include the users such as Google_bot etc by default. Please advise.. regards, Keil Sonter Website Hosting Services - EVE Corporation Classified Ad's, guides - Solar Sentinel
Keil Sonter	Posted - 2010.04.19 05:49:00 - [2] Hi, That was a fix but with a slight change in the ALTER in install\schemas\schema_data.sql Quote: ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR(10) NOT NULL AFTER user_form_salt DEFAULT ''; ALTER TABLE phpbb_users ADD COLUMN api_limitedkey VARCHAR(64) NOT NULL AFTER api_userid DEFAULT ''; ALTER TABLE phpbb_users ADD COLUMN character_id INTEGER UNSIGNED NOT NULL AFTER api_limitedkey DEFAULT 0; This should be ALTER TABLE phpbb_users ADD COLUMN api_userid VARCHAR(10) NOT NULL DEFAULT '' AFTER user_form_salt; ALTER TABLE phpbb_users ADD COLUMN api_limitedkey VARCHAR(64) NOT NULL DEFAULT '' AFTER api_userid; ALTER TABLE phpbb_users ADD COLUMN character_id INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER api_limitedkey; good work and thanks for your prompt response.. regards, Keil Sonter Website Hosting Services - EVE Corporation Classified Ad's, guides - Solar Sentinel

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.